<div id="GridCustomerAUMAndProductCompositionReport">
  <yu-panel title="网格客户AUM及产品构成报表">
    <yu-xform label-width="110px" ref="GridCustomerAUMAndProductCompositionReportInfoSearch" related-table-name="GridCustomerAUMAndProductCompositionReportTable" form-type="search"
              :custom-search-fn="searchFn">
      <yu-xform-group :column="3">
        <yu-xform-item label="机构名称" placeholder="机构名称" name="gridName" ctype="input"></yu-xform-item>
        <yu-xform-item label="所属网格" placeholder="所属网格" name="secondGridName" ctype="input"></yu-xform-item>
        <yu-xform-item label="档案号" placeholder="档案号" name="userNo" ctype="input"></yu-xform-item>
        <yu-xform-item label="网格员姓名" placeholder="网格员姓名" name="userName" ctype="input"></yu-xform-item>
        <yu-xform-item label="数据日期" placeholder="数据日期" ctype="datepicker" name="etlDt"></yu-xform-item>
      </yu-xform-group>
    </yu-xform>
    <div style="justify-content:space-between;display: flex">
      <div>
        <yu-button type="warning" v-loading="loading"  @click="exportExcel()" >导出数据</yu-button>
      </div>
    </div>
    <div style="height: 30px"></div>
    <yu-xtable ref="GridCustomerAUMAndProductCompositionReportTable" :base-params="GridCustomerAUMAndProductCompositionReportData" :data-url="funcDataUrl" request-type="get" row-number style="width: 100%">
      <yu-xtable-column prop="etlDt" label="数据日期" width="120px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gridName" label="机构名称" width="90px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="secondGridName" label="所属网格" width="110px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="userNo" label="档案号" width="90px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="userName" label="网格员姓名" width="90px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="custNum" label="网格全部客户数" width="90px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="custAum" label="网格全部客户AUM（万元）" width="90px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzCustNum" label="高净值客户数" width="130px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzCustAum" label="高净值客户AUM（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzDepAvg" label="高净值客户存款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzLoanAvg" label="高净值客户贷款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzFincAvgM" label="高净值客户理财月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="gjzFundAvgM" label="高净值客户基金月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdCustNum" label="财富高端客户数" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdCustAum" label="财富高端客户AUM（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdDepAvgM" label="财富高端客户存款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdLoanAvgM" label="财富高端客户贷款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdFincAvgM" label="财富高端客户理财月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfgdFundAvgM" label="财富高端客户基金月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgCustNum" label="财富中高端客户数" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgCustAum" label="财富中高端客户AUM（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgDepAvgM" label="财富中高端客户存款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgLoanAvgM" label="财富中高端客户贷款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgFincAvgM" label="财富中高端客户理财月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="cfzgFundAvgM" label="财富中高端客户基金月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdCustNum" label="中端客户数" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdCustAum" label="中端客户AUM（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdDepAvgM" label="中端客户存款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdLoanAvgM" label="中端客户贷款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdFincAvgM" label="中端客户理财月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="zdFundAvgM" label="中端客户基金月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzCustNum" label="大众客户数" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzCustAum" label="大众客户AUM（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzDepAvgM" label="大众客户存款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzLoanAvgM" label="大众客户贷款月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzFincAvgM" label="大众客户理财月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
      <yu-xtable-column prop="dzFundAvgM" label="大众客户基金月日均（万元）" width="160px" align="center" show-overflow-tooltip></yu-xtable-column>
    </yu-xtable>
  </yu-panel>
</div>
